+------+-------------+-------------------------------------------------------------+--------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+-------------+-------------------------------------------------------------+--------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+ | 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | | 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | | 92 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 93 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 94 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 95 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 96 | web_magento | localhost | oscar_prod_magento | Sleep | 463 | | NULL | 0.000 | | 304 | dr_magento | ec2-3-112-54-248.ap-northeast-1.compute.amazonaws.com:51294 | NULL | Binlog Dump | 419 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | 425 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 | | 507 | web_magento | localhost | oscar_prod_magento | Sleep | 404 | | NULL | 0.000 | | 519 | web_magento | localhost | oscar_prod_magento | Query | 132 | Waiting for table metadata lock | RENAME TABLE catalog_category_product_index_store1 TO catalog_category_product_index_store1_outdated | 0.000 | | 2683 | web_magento | localhost | oscar_prod_magento | Query | 189 | Sending data | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_categor | 0.000 | | 3101 | web_magento | localhost | oscar_prod_magento | Query | 129 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098a0b6047_53219349` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3108 | web_magento | localhost | oscar_prod_magento | Query | 125 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098da24863_94899899` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3109 | web_magento | localhost | oscar_prod_magento | Query | 125 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098de37e30_59207897` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3112 | web_magento | localhost | oscar_prod_magento | Query | 123 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098f74eea9_07449079` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3113 | web_magento | localhost | oscar_prod_magento | Query | 123 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098fe3dd10_96123269` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3115 | web_magento | localhost | oscar_prod_magento | Query | 122 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_sto | 0.000 | | 3136 | web_magento | localhost | oscar_prod_magento | Query | 109 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9099dc02561_67471037` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3153 | web_magento | localhost | oscar_prod_magento | Query | 103 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909a42e7dc1_14038716` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3159 | web_magento | localhost | oscar_prod_magento | Query | 99 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909a7e0b5d9_21796830` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3170 | web_magento | localhost | oscar_prod_magento | Query | 96 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909aa5ec689_31096069` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3178 | web_magento | localhost | oscar_prod_magento | Query | 96 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_sto | 0.000 | | 3182 | web_magento | localhost | oscar_prod_magento | Query | 95 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare | 0.000 | | 3189 | web_magento | localhost | oscar_prod_magento | Query | 95 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ac37f904_69175659` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3190 | web_magento | localhost | oscar_prod_magento | Query | 93 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ad9a9c81_20563243` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3191 | web_magento | localhost | oscar_prod_magento | Query | 93 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ae4da6f8_78630616` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3210 | web_magento | localhost | oscar_prod_magento | Query | 89 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b2474170_22315230` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3211 | web_magento | localhost | oscar_prod_magento | Query | 83 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b806a035_46535565` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3212 | web_magento | localhost | oscar_prod_magento | Query | 88 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b33014a0_14730001` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3216 | web_magento | localhost | oscar_prod_magento | Query | 87 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_sto | 0.000 | | 3222 | web_magento | localhost | oscar_prod_magento | Query | 83 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b79a17f2_99509787` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3228 | web_magento | localhost | oscar_prod_magento | Query | 81 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ba0b73c8_42332985` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3233 | web_magento | localhost | oscar_prod_magento | Query | 78 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909bd422ca2_08806062` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3236 | web_magento | localhost | oscar_prod_magento | Query | 75 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909bf7d5e73_36144645` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3238 | web_magento | localhost | oscar_prod_magento | Query | 75 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909c042de27_68839278` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3243 | web_magento | localhost | oscar_prod_magento | Query | 71 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909c3ab7587_07723470` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3245 | web_magento | localhost | oscar_prod_magento | Query | 69 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909c5f15a66_72292308` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3254 | web_magento | localhost | oscar_prod_magento | Query | 62 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cd1bf5d2_53934963` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3255 | web_magento | localhost | oscar_prod_magento | Query | 61 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cd918165_61395700` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3261 | web_magento | localhost | oscar_prod_magento | Query | 61 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cdee7902_48895903` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3278 | web_magento | localhost | oscar_prod_magento | Query | 60 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cf466de3_38512289` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3338 | web_magento | localhost | oscar_prod_magento | Query | 54 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909d54ba516_18843791` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3348 | web_magento | localhost | oscar_prod_magento | Query | 47 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909db7f3dd0_89045693` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3350 | web_magento | localhost | oscar_prod_magento | Query | 46 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare | 0.000 | | 3353 | web_magento | localhost | oscar_prod_magento | Query | 44 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909de9bd642_97310392` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3367 | web_magento | localhost | oscar_prod_magento | Query | 35 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_sto | 0.000 | | 3377 | web_magento | localhost | oscar_prod_magento | Query | 36 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909e732e5d3_22751286` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3403 | web_magento | localhost | oscar_prod_magento | Query | 33 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare | 0.000 | | 3408 | web_magento | localhost | oscar_prod_magento | Query | 30 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ed17af52_74623770` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3416 | web_magento | localhost | oscar_prod_magento | Query | 24 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_sto | 0.000 | | 3427 | web_magento | localhost | oscar_prod_magento | Query | 27 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f02d52f8_44423257` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3428 | web_magento | localhost | oscar_prod_magento | Query | 26 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f08798f1_99254584` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3439 | web_magento | localhost | oscar_prod_magento | Query | 20 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f6b51603_36684812` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3456 | web_magento | localhost | oscar_prod_magento | Query | 19 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare | 0.000 | | 3470 | web_magento | localhost | oscar_prod_magento | Query | 17 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f9796182_07320878` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3491 | web_magento | localhost | oscar_prod_magento | Query | 17 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare | 0.000 | | 3498 | web_magento | localhost | oscar_prod_magento | Query | 11 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_sto | 0.000 | | 3550 | web_magento | localhost | oscar_prod_magento | Query | 13 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare | 0.000 | | 3569 | web_magento | localhost | oscar_prod_magento | Query | 11 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0044adf6_45404482` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3571 | web_magento | localhost | oscar_prod_magento | Query | 10 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a00b98f02_65899830` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3577 | web_magento | localhost | oscar_prod_magento | Query | 9 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a022dba56_00214255` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3593 | web_magento | localhost | oscar_prod_magento | Query | 8 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a02ee2165_73836421` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3595 | web_magento | localhost | oscar_prod_magento | Query | 7 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a03d6c7d8_88931727` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3601 | web_magento | localhost | oscar_prod_magento | Query | 4 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a06827520_82244814` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3611 | web_magento | localhost | oscar_prod_magento | Query | 1 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a09ccff14_85415297` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3612 | web_magento | localhost | oscar_prod_magento | Query | 1 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare | 0.000 | | 3614 | web_magento | localhost | oscar_prod_magento | Query | 0 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0b280708_05432533` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3615 | web_magento | localhost | oscar_prod_magento | Query | 0 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0b272353_99908095` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | | 3617 | web_magento | localhost | oscar_prod_magento | Query | 0 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0b4b00a3_69227489` SELECT `main_select`.`entity_id`, SUM(score) AS `re | 0.000 | +------+-------------+-------------------------------------------------------------+--------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+ 73 rows in set (0.000 sec)